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