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