UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0L4uMlBozkK4fQc6rKbHPNf4OpE4zInfbijEkVa5O8='
WHERE
key_id = 'b720946404167a4b9be24a202e1b7f965e347a852f411927337e7ac71da63d75'
AND (
token = 'X0L4uMlBozkK4fQc6rKbHPNf4OpE4zInfbijEkVa5O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)