UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MnHL5LoV1VC07bBpq+DesUKxBs8H5IBUSK3MEKEBdVw='
WHERE
key_id = '246477c81a1d147d8ccc356ad0e6bf19712276b6856668884169b917afa8aab0'
AND (
token = 'MnHL5LoV1VC07bBpq+DesUKxBs8H5IBUSK3MEKEBdVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)