UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zlx21dK+qcjeyOj8M6WIxIm0OioRjnYrcjMX4bFL470='
WHERE
key_id = 'ac712456d7e9285cf47e3f364f8dd2454b62c0ca5e21aa4ef33fae4de9f5b5ed'
AND (
token = 'Zlx21dK+qcjeyOj8M6WIxIm0OioRjnYrcjMX4bFL470='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)