UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0I7dgg+2Ql4cg/LcaUusdbEvtg7RX0q9aAU5OmnEbgw='
WHERE
key_id = '1a80975d97a3b2b78ef5548eb04cc6609b10aee8fc86ec6999c4ecdac0913cd7'
AND (
token = '0I7dgg+2Ql4cg/LcaUusdbEvtg7RX0q9aAU5OmnEbgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)