UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ylA2qfx+pmVzhiFPwyqRmAJyxcWQGjyNYS4kYvYvwk4='
WHERE
key_id = 'ef7d8eda293c4b770e3c0076058ddd30c2e017b9a6acc6e1d5bd2b9bc7aa115d'
AND (
token = 'ylA2qfx+pmVzhiFPwyqRmAJyxcWQGjyNYS4kYvYvwk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)