UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ugRmNK6oyNG4Nfl8NjIjd9H575Hm0ep54HqNP4SIWgI='
WHERE
key_id = 'b2f6642023dc07f9d19360424be249e6d28c8f95dd894e810ca51f8b32b362fd'
AND (
token = 'ugRmNK6oyNG4Nfl8NjIjd9H575Hm0ep54HqNP4SIWgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)