UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KohT2mX9z0Lblqssz/3kbTkdIgxwt70xIe0DfV/3p7M='
WHERE
key_id = '8c9ed0aada2642c92c3fef3a795d652c18453e049a7e0ef6f81f7b7db767d9c0'
AND (
token = 'KohT2mX9z0Lblqssz/3kbTkdIgxwt70xIe0DfV/3p7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)