UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KOeDpPCotT99zCgrG7B5XXBQXNMFw6uWFvDRzFlyMOI='
WHERE
key_id = '7bc04364131d558d0885ba3469a2893e0bb6b0564e1103588d312881d91d4d8e'
AND (
token = 'KOeDpPCotT99zCgrG7B5XXBQXNMFw6uWFvDRzFlyMOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)