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