UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DQRinsoU8NKpoK9C9YnUURCsueo3YYN1AfoKg5i3xb0='
WHERE
key_id = '27362c71be0a501555a74a55af374a12b30c8358c27479d096a265a52e1d4d88'
AND (
token = 'DQRinsoU8NKpoK9C9YnUURCsueo3YYN1AfoKg5i3xb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)