UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YUUQhrJat7igyuUhWk/i8YpCUEgd84j0LEzaWu2Olr8='
WHERE
key_id = '7ab31bb81293442ffcfbd8a735a736d41503deefa70b76da13d57e21aa315738'
AND (
token = 'YUUQhrJat7igyuUhWk/i8YpCUEgd84j0LEzaWu2Olr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)