UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EMSXZSLlymgglhPZuAMIgJQhNc5aCgmEwA9O5VI/aZ4='
WHERE
key_id = '692d158623f8dba01504df8c377cdb32a33e3a0e45086e96d191df39afb178cd'
AND (
token = 'EMSXZSLlymgglhPZuAMIgJQhNc5aCgmEwA9O5VI/aZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)