UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y/GcEz6em9eURfMPoFmXfB09PICLXGFh9tLsH8Obdfs='
WHERE
key_id = '00392767ae811d0f88abff92de48846c34e33605df162426fcf9335e92bcb1ac'
AND (
token = 'Y/GcEz6em9eURfMPoFmXfB09PICLXGFh9tLsH8Obdfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)