UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXa9wbFbECzuYT4aLSaQvbKwi2Dt/MBmsKoLX9iEXjE='
WHERE
key_id = '690675e52ee3f2a5e947472c7140f93711421f502156035b1f7df6336b5a9099'
AND (
token = 'mXa9wbFbECzuYT4aLSaQvbKwi2Dt/MBmsKoLX9iEXjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)