UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pO33qa1+aTX/0OzWW6yFCIsR19ioMcEkCSg6MCUKRok='
WHERE
key_id = '3119b9400dbfc3c45933d96f665233e7c35b38a7b4ea947432560abf99b9a96c'
AND (
token = 'pO33qa1+aTX/0OzWW6yFCIsR19ioMcEkCSg6MCUKRok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)