UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNRupfWRW83SzsmxACK87x769IHC9+M0mfIiO363QQo='
WHERE
key_id = '99267a43016b1f55e9b381f28a49785740ef148831ac5f55d1740422a572908a'
AND (
token = 'sNRupfWRW83SzsmxACK87x769IHC9+M0mfIiO363QQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)