UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mEtCDvUm4J34o3RTmU4krKVNsnrd4WVLK7pFIpH0Ca8='
WHERE
key_id = 'd8d873895874ca5ec837f2320f540735b37798f4b7722a4befcbbee8987fe142'
AND (
token = 'mEtCDvUm4J34o3RTmU4krKVNsnrd4WVLK7pFIpH0Ca8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)