UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0J20N4G2TKddLGElLpSHhOq341leLnYC3Zla41DXTzQ='
WHERE
key_id = 'a42362fd70c2e9ac9ee02b4b17b8467caf88d403988eb468c67ce4691fac9dfb'
AND (
token = '0J20N4G2TKddLGElLpSHhOq341leLnYC3Zla41DXTzQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)