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