UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vNHSAYsAEJlnsl1gUPsbYrlEdlgoUghyt8cmbMtwbDM='
WHERE
key_id = '4b1c9b8d1b86e77114eb3eaa1e0713be38a20a1ed73a1e4f4fc20e2b82ed67c3'
AND (
token = 'vNHSAYsAEJlnsl1gUPsbYrlEdlgoUghyt8cmbMtwbDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)