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