UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fIvBFD6i12f1dm/6MSe+NRQ7LzO11QGvjJCzWwZC4i4='
WHERE
key_id = '46442cb7c02ea3ec861c78754418a1f7af7ab6b4b524798897c95127e8819ee3'
AND (
token = 'fIvBFD6i12f1dm/6MSe+NRQ7LzO11QGvjJCzWwZC4i4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)