UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpoOx8NQ9LE1BHk+86BVxD4x74xjmL77P3j1l6yMew0='
WHERE
key_id = 'd9668ada3e65dde3aa6c695e9b39535d21897fc54aa108f4f083252c72732e94'
AND (
token = 'zpoOx8NQ9LE1BHk+86BVxD4x74xjmL77P3j1l6yMew0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)