UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XaaPZieRXmIgbWWz4aAfxhaB5tmtnDLd9lUCvJ7/6f0='
WHERE
key_id = 'a27bfce40b8c24ed30da370a6228280134c4e4c134ce2ef78501eeee014e6078'
AND (
token = 'XaaPZieRXmIgbWWz4aAfxhaB5tmtnDLd9lUCvJ7/6f0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)