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