UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T732lddCkUsd2uq3jlO+80ymgIWo62FfcpNeW6rcBV4='
WHERE
key_id = 'd65d6d63b2ab1a4b04f83a142ab4054d0dec3a6cf0dd5e2edec0148ea025e9e6'
AND (
token = 'T732lddCkUsd2uq3jlO+80ymgIWo62FfcpNeW6rcBV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)