UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'miLVuaW9DIChrsjSp9DiOoHaWV0BiJQYNXq5lRdgofE='
WHERE
key_id = '0cf2644fcded2c8af07accb457783445a8fa9f2cfd8f0339f5a441b2f53399c2'
AND (
token = 'miLVuaW9DIChrsjSp9DiOoHaWV0BiJQYNXq5lRdgofE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)