UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDtqbqah+sYDSyDRvxc1jnjgrKHHlgx85muH+UITCmo='
WHERE
key_id = '86e514b514aaac4644c6c771fdadd53a88b5b1d74419cedeb784f2d5ddfb4435'
AND (
token = 'zDtqbqah+sYDSyDRvxc1jnjgrKHHlgx85muH+UITCmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)