UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+phQECsOJ111Qr5Yt9Vrw2u06d8W2/mfwyFizTxEHw='
WHERE
key_id = '7997fb43af5dde7488bce2fc2578e9380505e175cbbed604734e57e9eb0cc18a'
AND (
token = '7+phQECsOJ111Qr5Yt9Vrw2u06d8W2/mfwyFizTxEHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)