UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TqECTNvwAB9clMA6XaTMpu2ENN7lQKpE/C3rQHrhExY='
WHERE
key_id = 'c0e9a54d63952cf367e0ad8a7b74e625f227bb4cd7793c69d2abbd535190f4c7'
AND (
token = 'TqECTNvwAB9clMA6XaTMpu2ENN7lQKpE/C3rQHrhExY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)