UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fY6QVpJb3Bq0PTpvqHabeTp9AHSuvk7NBOk8BOAaQB8='
WHERE
key_id = 'e555ef2ddc1978d583aa54b9e6ae50273668ab0e7cf31c63231a2fd07e275bfc'
AND (
token = 'fY6QVpJb3Bq0PTpvqHabeTp9AHSuvk7NBOk8BOAaQB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)