UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRvNw2t3xAsmIkI2S1U0E+8CJyT2YiuuSQmvpfORxJM='
WHERE
key_id = 'a20d777ec799607856fb8b6707d6dc03b5b43bf624fe5edd745b1cf9a81b08e8'
AND (
token = 'BRvNw2t3xAsmIkI2S1U0E+8CJyT2YiuuSQmvpfORxJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)