UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j2y9W7lqBaPZoGpeSQqrtAZlDtilpHR/OuF74ngeL3Y='
WHERE
key_id = '11a196982ecc4c71fa8a0c6fc9c940f15930e1c9ac7c3ce9eb9770082b309b00'
AND (
token = 'j2y9W7lqBaPZoGpeSQqrtAZlDtilpHR/OuF74ngeL3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)