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