UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tkjKWe3uooSdWZMF48tjFLyIcF+t6grvi3z4jua+W44='
WHERE
key_id = 'be50378ecdd6c6eae564de10048eff93d5d4a0eb8c3ee534f74b3166dfb479f4'
AND (
token = 'tkjKWe3uooSdWZMF48tjFLyIcF+t6grvi3z4jua+W44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)