UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nyYBSE/1kzRyKQtWd8tFk8670Bq1+Nu0TIECb/QCV04='
WHERE
key_id = 'e92e8f2e21d22a9e33acef76ec8880de03a8a173308fd97331b51521c6da4630'
AND (
token = 'nyYBSE/1kzRyKQtWd8tFk8670Bq1+Nu0TIECb/QCV04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)