UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MMHZ/lndHzA2tWzRSqKUweeDgl5//6avB421kFH1WcM='
WHERE
key_id = 'bc6c2ed31e20b211b574d4bb86b432cafa7bd867d49359caf9f51e6f00313189'
AND (
token = 'MMHZ/lndHzA2tWzRSqKUweeDgl5//6avB421kFH1WcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)