UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nwQOLckbaq/WAr93DYySZM0VIX7DZI0zeUjWeh7IPmw='
WHERE
key_id = '810353b9958f96271fe4a62fb17930123e7888f33bcc289787ecd1427a954fc8'
AND (
token = 'nwQOLckbaq/WAr93DYySZM0VIX7DZI0zeUjWeh7IPmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)