UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/rxfs6sUKbNTf4ZohbpzLV8Iw/wv8zEHENIup8XxCOw='
WHERE
key_id = 'd061471d16dbca28fe09e93e7cb2bcac56fd9c01bc9a5785a34cb78078f48e0a'
AND (
token = '/rxfs6sUKbNTf4ZohbpzLV8Iw/wv8zEHENIup8XxCOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)