UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R87dKTA0tysOd/b+R55mSitf+Tb3+qCoPCi7iIL65wI='
WHERE
key_id = '8b2fb0725351c8493a9ba3fdcc2fc597b64252b91b7bb5d2847a6c9c5b52f193'
AND (
token = 'R87dKTA0tysOd/b+R55mSitf+Tb3+qCoPCi7iIL65wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)