UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9xlNCLIaGuKxuH1XxvmBeWb1o8Fyzgm/w0B7Qc+P4Y0='
WHERE
key_id = 'b2b0cbaf78ee60d5ae8b03a922e5ae1d30cb024fd9c44c436e77bc3b7c1136bf'
AND (
token = '9xlNCLIaGuKxuH1XxvmBeWb1o8Fyzgm/w0B7Qc+P4Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)