UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ocNUQVpKhz5pqwpVs3dFustdEe2OF1M7g19aAgVZpYk='
WHERE
key_id = '56edcde222f15a8f8ee05294836048cea65df5b21e0f44d65e6d3bc99a2ddb99'
AND (
token = 'ocNUQVpKhz5pqwpVs3dFustdEe2OF1M7g19aAgVZpYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)